Overview

Dataset statistics

Number of variables23
Number of observations382
Missing cells27
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory396.3 KiB
Average record size in memory1.0 KiB

Variable types

CAT11
NUM9
BOOL3

Reproduction

Analysis started2020-04-29 22:49:09.870418
Analysis finished2020-04-29 22:49:28.479005
Versionpandas-profiling v2.6.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
name has a high cardinality: 382 distinct values High cardinality
base_name has a high cardinality: 304 distinct values High cardinality
cpu_details has a high cardinality: 113 distinct values High cardinality
gpu has a high cardinality: 69 distinct values High cardinality
max_price is highly correlated with min_priceHigh Correlation
min_price is highly correlated with max_priceHigh Correlation
os_details is highly correlated with osHigh Correlation
os is highly correlated with os_detailsHigh Correlation
screen_surface has 10 (2.6%) missing values Missing
cpu_details has 6 (1.6%) missing values Missing
detachable_keyboard has 4 (1.0%) missing values Missing
ssd has 102 (26.7%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

UNIQUE
Distinct count382
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean250.6413613
Minimum0
Maximum509
Zeros1
Zeros (%)0.3%
Memory size3.1 KiB

Quantile statistics

Minimum0
5-th percentile20.05
Q1124.25
median248.5
Q3378.75
95-th percentile483.95
Maximum509
Range509
Interquartile range (IQR)254.5

Descriptive statistics

Standard deviation147.7659519
Coefficient of variation (CV)0.5895513462
Kurtosis-1.181700882
Mean250.6413613
Median Absolute Deviation (MAD)127.386297
Skewness0.01072708501
Sum95745
Variance21834.77655
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 509.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
509 1 0.3%
 
168 1 0.3%
 
157 1 0.3%
 
158 1 0.3%
 
159 1 0.3%
 
160 1 0.3%
 
161 1 0.3%
 
162 1 0.3%
 
164 1 0.3%
 
166 1 0.3%
 
Other values (372) 372 97.4%
 
ValueCountFrequency (%) 
0 1 0.3%
 
1 1 0.3%
 
2 1 0.3%
 
3 1 0.3%
 
4 1 0.3%
 
ValueCountFrequency (%) 
509 1 0.3%
 
507 1 0.3%
 
506 1 0.3%
 
505 1 0.3%
 
504 1 0.3%
 

id
Real number (ℝ≥0)

UNIQUE
Distinct count382
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21512.79843
Minimum3841
Maximum31422
Zeros0
Zeros (%)0.0%
Memory size3.1 KiB

Quantile statistics

Minimum3841
5-th percentile6987.45
Q117477.25
median23121
Q327581.75
95-th percentile30754.9
Maximum31422
Range27581
Interquartile range (IQR)10104.5

Descriptive statistics

Standard deviation7490.91792
Coefficient of variation (CV)0.3482075075
Kurtosis-0.5389184867
Mean21512.79843
Median Absolute Deviation (MAD)6096.899208
Skewness-0.7387486808
Sum8217889
Variance56113851.28
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 3841. 4076. 6306. 11942.5 17468. ... 29206.5 29627. 29634. 31416.5 31422. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
11539 1 0.3%
 
28332 1 0.3%
 
23813 1 0.3%
 
21462 1 0.3%
 
23203 1 0.3%
 
23204 1 0.3%
 
23205 1 0.3%
 
22862 1 0.3%
 
22139 1 0.3%
 
28330 1 0.3%
 
Other values (372) 372 97.4%
 
ValueCountFrequency (%) 
3841 1 0.3%
 
3897 1 0.3%
 
3916 1 0.3%
 
4062 1 0.3%
 
4066 1 0.3%
 
ValueCountFrequency (%) 
31422 1 0.3%
 
31421 1 0.3%
 
31420 1 0.3%
 
31418 1 0.3%
 
31417 1 0.3%
 

name
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE
Distinct count382
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
Dell XPS 13 - 13.3" UHD InfinityEdge, 8th Gen Intel Core i7, 16GB RAM, 1TB SSD - Silver - 9370
 
1
Dell I3565-A453BLK-PUS Laptop (Windows 10 Home, AMD Dual-Core A6-9220, 15.6" LCD Screen, Storage: 500 GB, RAM: 4 GB) Black
 
1
Newest HP 14-inch Chromebook HD SVA (1366 x 768) Display, Intel Dual Core Celeron N2840 2.16GHz, 4GB DD3L RAM, 16GB eMMc Hard Drive, Bluetooth, HDMI, Stereo Speakers, HD Webcam, Google Chrome OS
 
1
MSI GL63 8SC-059 15.6" Gaming Laptop, Intel Core i7-8750H, NVIDIA GeForce GTX1650, 8GB, 256GB Nvme SSD, Win10
 
1
2017 Dell Inspiron 15.6" HD Truelife LED-backlit Widescreen Laptop, Intel Core i7-6500U 2.5GHz, 12GB RAM, 1TB HDD, DVD +/- RW, Intel HD Graphics 520, 802.11a/b/g/n/ac WiFi, HDMI, Windows 10
 
1
Other values (377)
377
ValueCountFrequency (%) 
Dell XPS 13 - 13.3" UHD InfinityEdge, 8th Gen Intel Core i7, 16GB RAM, 1TB SSD - Silver - 9370 1 0.3%
 
Dell I3565-A453BLK-PUS Laptop (Windows 10 Home, AMD Dual-Core A6-9220, 15.6" LCD Screen, Storage: 500 GB, RAM: 4 GB) Black 1 0.3%
 
Newest HP 14-inch Chromebook HD SVA (1366 x 768) Display, Intel Dual Core Celeron N2840 2.16GHz, 4GB DD3L RAM, 16GB eMMc Hard Drive, Bluetooth, HDMI, Stereo Speakers, HD Webcam, Google Chrome OS 1 0.3%
 
MSI GL63 8SC-059 15.6" Gaming Laptop, Intel Core i7-8750H, NVIDIA GeForce GTX1650, 8GB, 256GB Nvme SSD, Win10 1 0.3%
 
2017 Dell Inspiron 15.6" HD Truelife LED-backlit Widescreen Laptop, Intel Core i7-6500U 2.5GHz, 12GB RAM, 1TB HDD, DVD +/- RW, Intel HD Graphics 520, 802.11a/b/g/n/ac WiFi, HDMI, Windows 10 1 0.3%
 
Razer Blade 15: World's Smallest 15.6" Gaming Laptop - 144Hz Full HD Thin Bezel - 8th Gen Intel Core i7-8750H 6 Core - NVIDIA GeForce GTX 1070 Max-Q - 16GB RAM - 256GB SSD - Windows 10 - CNC Aluminum 1 0.3%
 
Dell Inspiron 15 5000, 2019 Flagship 15.6 FHD Touchscreen Laptop, Intel 4-Core i5-8265U, 12G RAM, 16GB Optane Memory, 1TB HDD, BT4.1 Backlit Keyboard Fingerprint Reader MaxxAudio Win 10 1 0.3%
 
2019 Dell Latitude 3500 15.6" FHD Business Laptop Computer, 8th Gen Intel Quad-Core i5-8265U up to 3.9GHz, 16GB DDR4 RAM, 256GB SSD, 802.11ac WiFi, Bluetooth 5.0, USB 3.1, Windows 10 Professional 1 0.3%
 
ASUS ROG Strix GL702VS 17.3" Full HD Ultra Thin and Light Gaming Laptop,75HZ G-SYNC Display, GeForce GTX 1070 8GB, Intel i7-7700HQ 2.8 GHz, 12GB DDR4 RAM, 128GB SSD + 1TB 7200 rpm HDD 1 0.3%
 
HP 15-R011DX Laptop 15.6-Inch Intel Pentium 2.17GHz 4GB memory 750GB HDD Win 8.1 1 0.3%
 
Other values (372) 372 97.4%
 

Length

Max length203
Mean length144.4162304
Min length42
ValueCountFrequency (%) 
Uppercase_Letter 27 30.7%
 
Lowercase_Letter 27 30.7%
 
Decimal_Number 10 11.4%
 
Other_Punctuation 10 11.4%
 
Math_Symbol 3 3.4%
 
Space_Separator 2 2.3%
 
Initial_Punctuation 2 2.3%
 
Open_Punctuation 2 2.3%
 
Close_Punctuation 2 2.3%
 
Control 1 1.1%
 
Other values (2) 2 2.3%
 
ValueCountFrequency (%) 
Latin 54 61.4%
 
Common 34 38.6%
 
ValueCountFrequency (%) 
ASCII 80 96.4%
 
Punctuation 2 2.4%
 
Currency Symbols 1 1.2%
 

brand
Categorical

Distinct count16
Unique (%)4.2%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
Dell
81
HP
71
Asus
59
Lenovo
44
Acer
36
Other values (11)
91
ValueCountFrequency (%) 
Dell 81 21.2%
 
HP 71 18.6%
 
Asus 59 15.4%
 
Lenovo 44 11.5%
 
Acer 36 9.4%
 
Apple 21 5.5%
 
Other 20 5.2%
 
Microsoft 15 3.9%
 
MSI 9 2.4%
 
Alienware 7 1.8%
 
Other values (6) 19 5.0%
 

Length

Max length9
Mean length4.303664921
Min length2
ValueCountFrequency (%) 
Lowercase_Letter 19 59.4%
 
Uppercase_Letter 13 40.6%
 
ValueCountFrequency (%) 
Latin 32 100.0%
 
ValueCountFrequency (%) 
ASCII 32 100.0%
 

base_name
Categorical

HIGH CARDINALITY
UNIFORM
Distinct count304
Unique (%)79.6%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
HP
 
8
Dell Inspiron
 
5
Razer Blade 15
 
5
Sager NP7856
 
4
Apple MacBook Pro 2019
 
3
Other values (299)
357
ValueCountFrequency (%) 
HP 8 2.1%
 
Dell Inspiron 5 1.3%
 
Razer Blade 15 5 1.3%
 
Sager NP7856 4 1.0%
 
Apple MacBook Pro 2019 3 0.8%
 
Dell Latitude E6420 3 0.8%
 
Asus VivoBook F510UA 3 0.8%
 
Dell Inspiron 5570 3 0.8%
 
Lenovo IdeaPad 320 3 0.8%
 
Microsoft Surface Book 2 3 0.8%
 
Other values (294) 342 89.5%
 

Length

Max length42
Mean length19.45026178
Min length2
ValueCountFrequency (%) 
Uppercase_Letter 26 37.7%
 
Lowercase_Letter 25 36.2%
 
Decimal_Number 10 14.5%
 
Other_Punctuation 3 4.3%
 
Close_Punctuation 1 1.4%
 
Math_Symbol 1 1.4%
 
Space_Separator 1 1.4%
 
Open_Punctuation 1 1.4%
 
Dash_Punctuation 1 1.4%
 
ValueCountFrequency (%) 
Latin 51 73.9%
 
Common 18 26.1%
 
ValueCountFrequency (%) 
ASCII 69 100.0%
 

screen_size
Real number (ℝ≥0)

Distinct count17
Unique (%)4.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.68089005
Minimum10.1
Maximum17.3
Zeros0
Zeros (%)0.0%
Memory size3.1 KiB

Quantile statistics

Minimum10.1
5-th percentile11.6
Q113.3
median15.6
Q315.6
95-th percentile17.3
Maximum17.3
Range7.2
Interquartile range (IQR)2.3

Descriptive statistics

Standard deviation1.54847355
Coefficient of variation (CV)0.1054754544
Kurtosis-0.2551099603
Mean14.68089005
Median Absolute Deviation (MAD)1.328170829
Skewness-0.5790244509
Sum5608.1
Variance2.397770334
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[10.1 11.2 11.8 12.9 13.4 ... 14.5 15.5 15.8 17.15 17.3 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
15.6 190 49.7%
 
13.3 51 13.4%
 
14 49 12.8%
 
11.6 30 7.9%
 
17.3 28 7.3%
 
13.5 9 2.4%
 
12.3 5 1.3%
 
12.5 3 0.8%
 
12 3 0.8%
 
13.9 3 0.8%
 
Other values (7) 11 2.9%
 
ValueCountFrequency (%) 
10.1 2 0.5%
 
10.8 1 0.3%
 
11.6 30 7.9%
 
12 3 0.8%
 
12.2 2 0.5%
 
ValueCountFrequency (%) 
17.3 28 7.3%
 
17 1 0.3%
 
16 1 0.3%
 
15.6 190 49.7%
 
15.4 2 0.5%
 

pixels_x
Categorical

Distinct count17
Unique (%)4.5%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
1920
185
1366
124
3840
 
15
2560
 
14
1600
 
8
Other values (12)
 
36
ValueCountFrequency (%) 
1920 185 48.4%
 
1366 124 32.5%
 
3840 15 3.9%
 
2560 14 3.7%
 
1600 8 2.1%
 
3200 6 1.6%
 
3000 6 1.6%
 
2256 5 1.3%
 
1440 4 1.0%
 
2736 3 0.8%
 
Other values (7) 12 3.1%
 

Length

Max length4
Mean length4
Min length4
ValueCountFrequency (%) 
Decimal_Number 10 100.0%
 
ValueCountFrequency (%) 
Common 10 100.0%
 
ValueCountFrequency (%) 
ASCII 10 100.0%
 

pixels_y
Categorical

Distinct count14
Unique (%)3.7%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
1080
181
768
124
2160
 
16
900
 
12
1600
 
12
Other values (9)
37
ValueCountFrequency (%) 
1080 181 47.4%
 
768 124 32.5%
 
2160 16 4.2%
 
900 12 3.1%
 
1600 12 3.1%
 
1800 8 2.1%
 
1440 7 1.8%
 
2000 6 1.6%
 
1504 5 1.3%
 
800 3 0.8%
 
Other values (4) 8 2.1%
 

Length

Max length4
Mean length3.636125654
Min length3
ValueCountFrequency (%) 
Decimal_Number 9 100.0%
 
ValueCountFrequency (%) 
Common 9 100.0%
 
ValueCountFrequency (%) 
ASCII 9 100.0%
 

screen_surface
Categorical

MISSING
Distinct count4
Unique (%)1.1%
Missing10
Missing (%)2.6%
Memory size3.1 KiB
Glossy
185
Matte
173
glossy
 
11
matte
 
3
ValueCountFrequency (%) 
Glossy 185 48.4%
 
Matte 173 45.3%
 
glossy 11 2.9%
 
matte 3 0.8%
 
(Missing) 10 2.6%
 

Length

Max length6
Mean length5.460732984
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 10 83.3%
 
Uppercase_Letter 2 16.7%
 
ValueCountFrequency (%) 
Latin 12 100.0%
 
ValueCountFrequency (%) 
ASCII 12 100.0%
 
Distinct count2
Unique (%)0.5%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
0
255
1
127
ValueCountFrequency (%) 
0 255 66.8%
 
1 127 33.2%
 

cpu
Categorical

Distinct count22
Unique (%)5.8%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
Intel Core i7
137
Intel Core i5
107
Intel Celeron
49
Intel Core i3
 
21
AMD Ryzen 5
 
12
Other values (17)
56
ValueCountFrequency (%) 
Intel Core i7 137 35.9%
 
Intel Core i5 107 28.0%
 
Intel Celeron 49 12.8%
 
Intel Core i3 21 5.5%
 
AMD Ryzen 5 12 3.1%
 
Intel Pentium 10 2.6%
 
AMD A6 10 2.6%
 
Intel Core m3 9 2.4%
 
AMD A12 6 1.6%
 
Intel Atom 4 1.0%
 
Other values (12) 17 4.5%
 

Length

Max length14
Mean length12.45026178
Min length6
ValueCountFrequency (%) 
Lowercase_Letter 20 47.6%
 
Uppercase_Letter 12 28.6%
 
Decimal_Number 9 21.4%
 
Space_Separator 1 2.4%
 
ValueCountFrequency (%) 
Latin 32 76.2%
 
Common 10 23.8%
 
ValueCountFrequency (%) 
ASCII 42 100.0%
 

cpu_details
Categorical

HIGH CARDINALITY
MISSING
Distinct count113
Unique (%)30.1%
Missing6
Missing (%)1.6%
Memory size3.1 KiB
Intel Core i7-9750H 2.6 GHz (9th gen Coffee Lake Hexa-Core with Hyper-Threading)
 
34
Intel Core i7-8750H 2.2 GHz (8th gen Coffee Lake Hexa-Core with Hyper-Threading)
 
26
Intel Core i5-7200U 2.5 GHz (7th gen Kaby Lake Dual-Core with Hyper-Threading)
 
18
Intel Celeron N3060 1.6 GHz (Braswell Dual-Core)
 
17
Intel Core i7-8550U 1.8 GHz (8th gen Kaby Lake R Quad-Core with Hyper-Threading)
 
15
Other values (108)
266
ValueCountFrequency (%) 
Intel Core i7-9750H 2.6 GHz (9th gen Coffee Lake Hexa-Core with Hyper-Threading) 34 8.9%
 
Intel Core i7-8750H 2.2 GHz (8th gen Coffee Lake Hexa-Core with Hyper-Threading) 26 6.8%
 
Intel Core i5-7200U 2.5 GHz (7th gen Kaby Lake Dual-Core with Hyper-Threading) 18 4.7%
 
Intel Celeron N3060 1.6 GHz (Braswell Dual-Core) 17 4.5%
 
Intel Core i7-8550U 1.8 GHz (8th gen Kaby Lake R Quad-Core with Hyper-Threading) 15 3.9%
 
Intel Core i7-7700HQ 2.8 GHz (7th gen Kaby Lake Quad-Core with Hyper-Threading) 13 3.4%
 
Intel Core i5-8250U 1.6 GHz (8th gen Kaby Lake R Quad-Core with Hyper-Threading) 11 2.9%
 
Intel Core i7-8565U 1.8 GHz (8th gen Whiskey Lake Quad-Core with Hyper-Threading) 9 2.4%
 
Intel Core i5-8265U 1.6 GHz (8th gen Whiskey Lake Quad-Core with Hyper-Threading) 8 2.1%
 
AMD Ryzen 5 2500U 2.0 GHz (Quad-Core with Simultaneous Multi-Threading) 8 2.1%
 
Other values (103) 217 56.8%
 

Length

Max length82
Mean length70.34816754
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 24 36.9%
 
Lowercase_Letter 24 36.9%
 
Decimal_Number 10 15.4%
 
Other_Punctuation 2 3.1%
 
Close_Punctuation 1 1.5%
 
Math_Symbol 1 1.5%
 
Space_Separator 1 1.5%
 
Open_Punctuation 1 1.5%
 
Dash_Punctuation 1 1.5%
 
ValueCountFrequency (%) 
Latin 48 73.8%
 
Common 17 26.2%
 
ValueCountFrequency (%) 
ASCII 65 100.0%
 

detachable_keyboard
Boolean

MISSING
Distinct count2
Unique (%)0.5%
Missing4
Missing (%)1.0%
Memory size3.1 KiB
0
366
1
 
12
(Missing)
 
4
ValueCountFrequency (%) 
0 366 95.8%
 
1 12 3.1%
 
(Missing) 4 1.0%
 
Distinct count2
Unique (%)0.5%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
0
266
1
116
ValueCountFrequency (%) 
0 266 69.6%
 
1 116 30.4%
 

gpu
Categorical

HIGH CARDINALITY
Distinct count69
Unique (%)18.1%
Missing1
Missing (%)0.3%
Memory size3.1 KiB
Intel UHD 620
49
Intel HD 620
 
33
Intel HD
 
31
Intel HD 400
 
18
NVIDIA GeForce GTX 1060
 
13
Other values (64)
237
ValueCountFrequency (%) 
Intel UHD 620 49 12.8%
 
Intel HD 620 33 8.6%
 
Intel HD 31 8.1%
 
Intel HD 400 18 4.7%
 
NVIDIA GeForce GTX 1060 13 3.4%
 
Intel HD 520 12 3.1%
 
NVIDIA GeForce RTX 2070 12 3.1%
 
NVIDIA GeForce GTX 1050 Ti 12 3.1%
 
NVIDIA GeForce RTX 2060 11 2.9%
 
NVIDIA GeForce GTX 1050 10 2.6%
 
Other values (59) 180 47.1%
 

Length

Max length29
Mean length15.72774869
Min length3
ValueCountFrequency (%) 
Uppercase_Letter 16 34.0%
 
Lowercase_Letter 16 34.0%
 
Decimal_Number 10 21.3%
 
Space_Separator 2 4.3%
 
Close_Punctuation 1 2.1%
 
Open_Punctuation 1 2.1%
 
Dash_Punctuation 1 2.1%
 
ValueCountFrequency (%) 
Latin 32 68.1%
 
Common 15 31.9%
 
ValueCountFrequency (%) 
ASCII 45 100.0%
 

os
Categorical

HIGH CORRELATION
Distinct count3
Unique (%)0.8%
Missing2
Missing (%)0.5%
Memory size3.1 KiB
Windows
324
Chrome OS
 
36
macOS
 
20
ValueCountFrequency (%) 
Windows 324 84.8%
 
Chrome OS 36 9.4%
 
macOS 20 5.2%
 
(Missing) 2 0.5%
 

Length

Max length9
Mean length7.062827225
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 12 70.6%
 
Uppercase_Letter 4 23.5%
 
Space_Separator 1 5.9%
 
ValueCountFrequency (%) 
Latin 16 94.1%
 
Common 1 5.9%
 
ValueCountFrequency (%) 
ASCII 17 100.0%
 

os_details
Categorical

HIGH CORRELATION
Distinct count17
Unique (%)4.5%
Missing2
Missing (%)0.5%
Memory size3.1 KiB
Windows 10 Home
185
Windows 10
75
Chrome OS
 
36
Windows 10 Pro
 
30
Windows 8.1
 
19
Other values (12)
 
35
ValueCountFrequency (%) 
Windows 10 Home 185 48.4%
 
Windows 10 75 19.6%
 
Chrome OS 36 9.4%
 
Windows 10 Pro 30 7.9%
 
Windows 8.1 19 5.0%
 
macOS Mojave 9 2.4%
 
Windows 10 S 8 2.1%
 
OS X Yosemite 3 0.8%
 
macOS High Sierra 3 0.8%
 
Windows 7 3 0.8%
 
Other values (7) 9 2.4%
 

Length

Max length33
Mean length12.9921466
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 20 52.6%
 
Uppercase_Letter 12 31.6%
 
Decimal_Number 4 10.5%
 
Other_Punctuation 1 2.6%
 
Space_Separator 1 2.6%
 
ValueCountFrequency (%) 
Latin 32 84.2%
 
Common 6 15.8%
 
ValueCountFrequency (%) 
ASCII 38 100.0%
 

ram
Real number (ℝ≥0)

Distinct count9
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9.882198953
Minimum2
Maximum64
Zeros0
Zeros (%)0.0%
Memory size3.1 KiB

Quantile statistics

Minimum2
5-th percentile4
Q14
median8
Q316
95-th percentile16
Maximum64
Range62
Interquartile range (IQR)12

Descriptive statistics

Standard deviation6.611788357
Coefficient of variation (CV)0.6690604378
Kurtosis13.03672121
Mean9.882198953
Median Absolute Deviation (MAD)4.904320057
Skewness2.506018608
Sum3775
Variance43.71574528
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 2. 2.5 3.5 5. 7. 10. 14. 24. 64. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
8 145 38.0%
 
16 100 26.2%
 
4 87 22.8%
 
12 13 3.4%
 
2 13 3.4%
 
32 11 2.9%
 
6 11 2.9%
 
64 1 0.3%
 
3 1 0.3%
 
ValueCountFrequency (%) 
2 13 3.4%
 
3 1 0.3%
 
4 87 22.8%
 
6 11 2.9%
 
8 145 38.0%
 
ValueCountFrequency (%) 
64 1 0.3%
 
32 11 2.9%
 
16 100 26.2%
 
12 13 3.4%
 
8 145 38.0%
 

ssd
Real number (ℝ≥0)

ZEROS
Distinct count13
Unique (%)3.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean202.4450262
Minimum0
Maximum2000
Zeros102
Zeros (%)26.7%
Memory size3.1 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median128
Q3256
95-th percentile512
Maximum2000
Range2000
Interquartile range (IQR)256

Descriptive statistics

Standard deviation249.1609876
Coefficient of variation (CV)1.230758751
Kurtosis8.363029131
Mean202.4450262
Median Absolute Deviation (MAD)184.4206847
Skewness2.213610991
Sum77334
Variance62081.19776
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 4. 12. 48. 96. ... 253. 378. 756. 1500. 2000.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 102 26.7%
 
256 86 22.5%
 
128 57 14.9%
 
512 46 12.0%
 
32 31 8.1%
 
16 17 4.5%
 
500 14 3.7%
 
1000 13 3.4%
 
64 12 3.1%
 
2000 1 0.3%
 
Other values (3) 3 0.8%
 
ValueCountFrequency (%) 
0 102 26.7%
 
8 1 0.3%
 
16 17 4.5%
 
32 31 8.1%
 
64 12 3.1%
 
ValueCountFrequency (%) 
2000 1 0.3%
 
1000 13 3.4%
 
512 46 12.0%
 
500 14 3.7%
 
256 86 22.5%
 

storage
Real number (ℝ≥0)

Distinct count23
Unique (%)6.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean583.0209424
Minimum16
Maximum4000
Zeros0
Zeros (%)0.0%
Memory size3.1 KiB

Quantile statistics

Minimum16
5-th percentile32
Q1128
median500
Q31000
95-th percentile1256
Maximum4000
Range3984
Interquartile range (IQR)872

Descriptive statistics

Standard deviation528.9840851
Coefficient of variation (CV)0.9073157525
Kurtosis5.318623968
Mean583.0209424
Median Absolute Deviation (MAD)421.8910666
Skewness1.641095714
Sum222714
Variance279824.1623
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 16. 48. 96. 154. 218. ... 631. 875. 1004. 1506. 4000.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1000 77 20.2%
 
256 72 18.8%
 
512 44 11.5%
 
128 37 9.7%
 
32 31 8.1%
 
500 29 7.6%
 
1128 20 5.2%
 
16 17 4.5%
 
1256 14 3.7%
 
64 12 3.1%
 
Other values (13) 29 7.6%
 
ValueCountFrequency (%) 
16 17 4.5%
 
32 31 8.1%
 
64 12 3.1%
 
128 37 9.7%
 
180 1 0.3%
 
ValueCountFrequency (%) 
4000 1 0.3%
 
2512 1 0.3%
 
2500 4 1.0%
 
2256 1 0.3%
 
2000 3 0.8%
 

weight
Real number (ℝ≥0)

Distinct count177
Unique (%)46.6%
Missing2
Missing (%)0.5%
Infinite0
Infinite (%)0.0%
Mean4.224631579
Minimum1.37
Maximum9.74
Zeros0
Zeros (%)0.0%
Memory size3.1 KiB

Quantile statistics

Minimum1.37
5-th percentile2.4195
Q13.035
median4.41
Q35
95-th percentile6.28
Maximum9.74
Range8.37
Interquartile range (IQR)1.965

Descriptive statistics

Standard deviation1.323587362
Coefficient of variation (CV)0.3133024353
Kurtosis1.24682245
Mean4.224631579
Median Absolute Deviation (MAD)1.067452078
Skewness0.6314755394
Sum1605.36
Variance1.751883505
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
4.85 22 5.8%
 
4.6 11 2.9%
 
4.63 10 2.6%
 
2.6 8 2.1%
 
3.7 8 2.1%
 
5 8 2.1%
 
5.07 8 2.1%
 
5.29 7 1.8%
 
5.95 7 1.8%
 
3.02 6 1.6%
 
Other values (167) 285 74.6%
 
ValueCountFrequency (%) 
1.37 1 0.3%
 
1.54 1 0.3%
 
1.66 1 0.3%
 
1.7 2 0.5%
 
1.74 1 0.3%
 
ValueCountFrequency (%) 
9.74 1 0.3%
 
9.7 1 0.3%
 
8.82 1 0.3%
 
8.33 1 0.3%
 
8.3 1 0.3%
 

min_price
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count323
Unique (%)84.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean818.3007068
Minimum69
Maximum2999.11
Zeros0
Zeros (%)0.0%
Memory size3.1 KiB

Quantile statistics

Minimum69
5-th percentile178.8575
Q1385.1325
median659.95
Q31164
95-th percentile1864.2495
Maximum2999.11
Range2930.11
Interquartile range (IQR)778.8675

Descriptive statistics

Standard deviation559.6242988
Coefficient of variation (CV)0.6838858798
Kurtosis0.4485435557
Mean818.3007068
Median Absolute Deviation (MAD)453.6603461
Skewness0.9923282704
Sum312590.87
Variance313179.3558
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 69. 157.49 449.985 449.995 849.935 ... 1299.9 1499.055 1499.985 2124.495 2999.11 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
999.99 5 1.3%
 
1299 4 1.0%
 
379.99 4 1.0%
 
1099 3 0.8%
 
1549 3 0.8%
 
789 3 0.8%
 
899.99 3 0.8%
 
499.99 3 0.8%
 
1399 3 0.8%
 
449.99 3 0.8%
 
Other values (313) 348 91.1%
 
ValueCountFrequency (%) 
69 1 0.3%
 
69.99 1 0.3%
 
84.99 1 0.3%
 
119.98 1 0.3%
 
120.94 1 0.3%
 
ValueCountFrequency (%) 
2999.11 1 0.3%
 
2693.39 1 0.3%
 
2568.92 1 0.3%
 
2499.11 1 0.3%
 
2299.99 1 0.3%
 

max_price
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count318
Unique (%)83.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean854.953089
Minimum76
Maximum2999.11
Zeros0
Zeros (%)0.0%
Memory size3.1 KiB

Quantile statistics

Minimum76
5-th percentile187.1485
Q1401.4475
median674.95
Q31231.52
95-th percentile1999.11
Maximum2999.11
Range2923.11
Interquartile range (IQR)830.0725

Descriptive statistics

Standard deviation585.8485171
Coefficient of variation (CV)0.6852405408
Kurtosis0.2397608646
Mean854.953089
Median Absolute Deviation (MAD)477.2918596
Skewness0.9652383737
Sum326592.08
Variance343218.485
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 76. 160.245 648.995 649.495 897.74 ... 1499.875 1798.99 1799.66 2124.495 2999.11 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
899.99 5 1.3%
 
999.99 5 1.3%
 
649 5 1.3%
 
1999.11 4 1.0%
 
449.99 4 1.0%
 
1699 4 1.0%
 
1299 3 0.8%
 
1799.33 3 0.8%
 
899 3 0.8%
 
399 3 0.8%
 
Other values (308) 343 89.8%
 
ValueCountFrequency (%) 
76 1 0.3%
 
78.9 1 0.3%
 
90.9 1 0.3%
 
123 1 0.3%
 
125.9 1 0.3%
 
ValueCountFrequency (%) 
2999.11 1 0.3%
 
2699.99 1 0.3%
 
2652.49 1 0.3%
 
2499.99 1 0.3%
 
2499.97 1 0.3%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

df_indexidnamebrandbase_namescreen_sizepixels_xpixels_yscreen_surfacetouchscreencpucpu_detailsdetachable_keyboarddiscrete_gpugpuosos_detailsramssdstorageweightmin_pricemax_price
090296352019 Dell Latitude 3500 15.6" FHD Business Laptop Computer, 8th Gen Intel Quad-Core i5-8265U up to 3.9GHz, 16GB DDR4 RAM, 256GB SSD, 802.11ac WiFi, Bluetooth 5.0, USB 3.1, Windows 10 ProfessionalDellDell Latitude 350015.619201080Matte0Intel Core i5Intel Core i5-8265U 1.6 GHz (8th gen Whiskey Lake Quad-Core with Hyper-Threading)0.00Intel UHD 620WindowsWindows 10 Pro162562564.37849.99849.99
110727576Asus ZenBook 15 Ultra Slim Compact Laptop 15.6” FHD 4-Way NanoEdge, Intel Core i7-8565U Processor, 16GB DDR4, 512GB PCIe SSD, GeForce GTX 1050, Ir Camera, Windows 10, UX533FD-DH74, Royal BlueAsusAsus ZenBook UX533FD15.619201080Glossy0Intel Core i7Intel Core i7-8565U 1.8 GHz (8th gen Whiskey Lake Quad-Core with Hyper-Threading)0.01NVIDIA GeForce GTX 1050 Max-QWindowsWindows 10 Home165125123.721382.991498.97
233626131MSI GS63VR Stealth Pro-230 15.6" Ultra Thin and Light Gaming Laptop Intel Core i7-7700HQ GTX 1060 16GB 256GB NVMe SSD + 2TB VR Ready - Metal ChassisMSIMSI GS63VR Stealth Pro15.619201080Matte0Intel Core i7Intel Core i7-7700HQ 2.8 GHz (7th gen Kaby Lake Quad-Core with Hyper-Threading)0.01NVIDIA GeForce GTX 1060WindowsWindows 10 Home1625622563.961999.111999.11
349921463Dell Latitude E6430 14in Notebook PC - Intel Core i5-3320 2.6GHz 8GB 320gb SATA Windows 10 Professional (Renewed)DellDell Latitude E643014.01366768Matte0Intel Core i5Intel Core i5-3320M 2.6 GHz (3rd gen Ivy Bridge Dual-Core with Hyper-Threading)0.00Intel HD 4000WindowsWindows 10 Pro803204.44179.68214.99
420828215Acer Chromebook R 11 Convertible Laptop, Celeron N3060, 11.6" HD Touch, 4GB DDR3L, 32GB eMMC, C738T-C7KDAcerAcer Chromebook R C738T11.61366768Glossy1Intel CeleronIntel Celeron N3060 1.6 GHz (Braswell Dual-Core)0.00Intel HD 400Chrome OSChrome OS432322.76199.99214.90
5154081Dell Inspiron i5547-3753sLV 15.6-Inch Laptop (1.7 GHz Intel Core i5-4210U Processor, 6GB DDR3, 1TB HDD, Windows 8.1) SilverDellDell Inspiron i5547-3753sLV15.61366768Glossy0Intel Core i5Intel Core i5-4210U 1.7 GHz (4th gen Haswell Dual-Core with Hyper-Threading)0.00Intel HD 4400WindowsWindows 8.16010246.00399.90399.90
643722132Acer Aspire 5, 15.6" Full HD, 8th Gen Intel Core i5-8250U, GeForce MX150, 8GB DDR4 Memory, 256GB SSD, A515-51G-515JAcerAcer Aspire A515-51G15.619201080Matte0Intel Core i5Intel Core i5-8250U 1.6 GHz (8th gen Quad-Core Kaby Lake R with Hyper-Threading)0.01NVIDIA GeForce MX150WindowsWindows 10 Home82562564.85583.99605.99
728330292New Apple MacBook Air (13-inch, 8GB RAM, 256GB Storage) - Space GrayAppleApple MacBook Air 201913.325601600Glossy0Intel Core i5Intel Core i5-8210Y 1.6 GHz (8th gen Amber Lake Y Dual-Core with Hyper-Threading)0.00Intel UHD 617macOSmacOS Mojave82562562.751099.001232.00
816227730Acer Predator Helios 300 Gaming Laptop PC, 15.6 inches Full HD 144Hz 3ms IPS Display, Intel i7-9750H, GTX 1660 Ti 6GB, 16GB DDR4, 256GB PCIe NVMe SSD, Backlit Keyboard, PH315-52-78VLAcerAcer Predator Helios 300 PH315-5215.619201080Matte0Intel Core i7Intel Core i7-9750H 2.6 GHz (9th gen Coffee Lake Hexa-Core with Hyper-Threading)0.01NVIDIA GeForce GTX 1660 TiWindowsWindows 10 Home162562565.511094.001099.99
919610369Asus Transformer Book Flip Tp200sa-uhbf Signature Edition 2 in 1 PcAsusAsus Transformer Book Flip Tp200sa-uhbf11.61366768Glossy1Intel CeleronIntel Celeron N3050 1.6 GHz (Braswell Dual-Core)0.00Intel HDWindowsWindows 10232322.60219.72219.72

Last rows

df_indexidnamebrandbase_namescreen_sizepixels_xpixels_yscreen_surfacetouchscreencpucpu_detailsdetachable_keyboarddiscrete_gpugpuosos_detailsramssdstorageweightmin_pricemax_price
37222224432HP Probook 11-G2 11.6" HD Touch-Screen Business Laptop, Intel Pentium 4405U (2.1GHz), 8GB Memory, 128GB SSD Storage, Intel HD Graphics 510, Windows 10 Pro - GrayHPHP ProBook 11 EE G211.61366768Matte1Intel PentiumIntel Pentium 4405U 2.1 GHz (Skylake Dual-Core)0.00Intel HD 510WindowsWindows 10 Pro81281283.76328.00337.14
3736230515Prostar P950RF 15.6 Inches FHD 144Hz, Intel i7-9750H, RTX 2070, 32GB 2666Mhz DDR4, 500GB NVMe SSD, 2TB SSHD, Windows 10 Home, Thin Gaming Laptop,1-Year WarrantyOtherProstar P950RF15.619201080Matte0Intel Core i7Intel Core i7-9750H 2.6 GHz (9th gen Coffee Lake Hexa-Core with Hyper-Threading)0.01NVIDIA GeForce RTX 2070WindowsWindows 10 Home3250025004.601679.001799.00
37442230753Sager NP8957 0.78 Inches Thin & Light Gaming Laptop, 15.6 Inches FHD 144Hz Display, Intel Core i7-9750H, NVIDIA RTX 2070 8GB DDR6, 16GB RAM, 500GB NVMe SSD + 1TB HDD, Windows 10 HomeOtherSager NP895715.619201080Matte0Intel Core i7Intel Core i7-9750H 2.6 GHz (9th gen Coffee Lake Hexa-Core with Hyper-Threading)0.01NVIDIA GeForce RTX 2070WindowsWindows 10 Home1650015004.601549.001599.00
37513026368ASUS ROG Strix Scar Edition 17.3” 120Hz 3ms Gaming Laptop, 8th-Gen Intel Core i7-8750H Processor (up to 3.9GHz), GTX 1050 Ti 4GB, 16GB DDR4, 128GB PCIe SSD + 1TB Hybrid HDD, Windows 10 - GL703GE-ES73AsusAsus ROG Strix GL703GE Scar Edition17.319201080Matte0Intel Core i7Intel Core i7-8750H 2.2 GHz (8th gen Coffee Lake Hexa-Core with Hyper-Threading)0.01NVIDIA GeForce GTX 1050 TiWindowsWindows 10 Home1612811286.721249.001249.00
3761878061Lenovo - IdeaPad 100s 11.6" Laptop / Intel Atom Z3735F/ 2GB Memory / 32GB eMMC Flash Memory / Webcam / Windows 10- RedLenovoLenovo IdeaPad 100S11.61366768Glossy0Intel AtomIntel Atom Z3735F 1.33 GHz (Bay Trail Quad-Core)0.00Intel HDWindowsWindows 10232322.20468.88468.88
3772319855Apple MacBook Air MJVM2LL/A 11.6-Inch laptop(1.6 GHz Intel i5, 128 GB SSD, Integrated Intel HD Graphics 6000, Mac OS X Yosemite (Renewed)AppleApple MacBook Air MJVM2LL/A11.61366768glossy0Intel Core i5Intel Core i5-5250U 1.6 GHz (5th gen Broadwell Dual-Core with Hyper-Threading)NaN0Intel HD 6000macOSOS X Yosemite41281282.38380.44405.82
3784330513Prostar NH58RDQ 15.6 Inches FHD IPS 144Hz 5ms, Intel i7-9750H, RTX 2060, 32GB 2666Mhz DDR4, 500GB NVMe SSD, 1TB SSHD, Windows 10 Home, Slim Bezel Gaming Laptop, 1-Year WarrantyOtherProstar NH58RDQ15.619201080Matte0Intel Core i7Intel Core i7-9750H 2.6 GHz (9th gen Coffee Lake Hexa-Core with Hyper-Threading)0.01NVIDIA GeForce RTX 2060WindowsWindows 10 Home3250015005.001399.001449.00
37945026098Asus ROG Strix Scar II Gaming Laptop, 15.6” 144Hz IPS Type Full HD, NVIDIA GeForce RTX 2070, Intel Core i7-8750H, 16GB DDR4, 512GB PCIe Nvme SSD, RGB KB, Windows 10, GL504GW-DS74AsusAsus ROG Strix Scar II GL504GW15.619201080Matte0Intel Core i7Intel Core i7-8750H 2.2 GHz (8th gen Coffee Lake Hexa-Core with Hyper-Threading)0.01NVIDIA GeForce RTX 2070WindowsWindows 10 Home165125125.291689.991749.99
38007774Lenovo Flex 3 15.6-Inch Touchscreen Laptop (Core i7, 8 GB RAM, 1 TB HDD, Windows 10) 80R40006USLenovoLenovo Flex 3 80JM002CUS15.619201080Glossy1Intel Core i7Intel Core i7-5500U 2.40 GHz (5th gen Broadwell Dual-Core with Hyper-Threading)0.00Intel HDWindowsWindows 108010004.60899.00899.00
38120127889Acer Nitro 5 - 15.6in Laptop AMD Ryzen 5 2500U 2GHz 8GB Ram 1TB HDD Windows 10 Home (Renewed)AcerAcer Nitro 5 AN515-4215.619201080Matte0AMD Ryzen 5AMD Ryzen 5 2500U 2.0 GHz (Quad-Core with Simultaneous Multi-Threading)0.01AMD Radeon RX 560XWindowsWindows 10 Home8010005.95529.00529.99